{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Riders & Times","Results","Standards"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":34,"n_cols":5,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
["What is in this spreadsheet"]
[]
[null,"There are 4 Sheets (including this one)"]
[null,null,"Instructions:  You're looking at it"]
[null,null,"Riders & Times: Race Information"]
[null,null,"Results:  Results based on finish or standard times"]
[null,null,"Standards:  Time standards for 16, 40 and 80km distances (Avoid modifying this page unless time standards change)."]
[]
[]
["Race Setup"]
[]
[null,"All race information is entered on the \"Riders & Times\" sheet"]
[]
[]
[null,"Adding Race Information"]
[null,null,"Enter the race distance in KM"]
[null,null,"Enter the standards distance you want to use.  This is either 16, 40 or 80km"]
[null,null,"Clear previous data from the following columns:  Rider, Team, Age, Finish Time"]
[null,null,null,"     (clear the values only so the formatting does not get messed up)"]
[null,null,"Add Rider data as follows"]
[null,null,null,"Rider","Mandatory"]
[null,null,null,"Team","Optional"]
[null,null,null,"Gender","Select or enter M or F"]
[null,null,null,"Age","Mandatory"]
[null,null,null,"Finish Time","Mandatory (times must be entered in h:mm:ss format.  If there are no hours, use 0.  eg  0:22:41)"]
[null,null,"When both age and gender are defined for a rider, the spreadsheet will calculate the standard time as follows:"]
[null,null,null,"Locates the age standard record in the Standards sheet based on age and gender"]
[null,null,null,"Retrieves the 16, 40 or 80km standard time as instructed"]
[null,null,null,"Adjusts the standard time based on the actual race distance"]
[null,null,"When you enter a finish time, the spreadsheet will populate the Std column with the difference between the standard and finish times"]
[]
["Results"]
[null,"To generate results, go to \"Results\" sheet"]
[null,"Click the appropriate button to get results based on Finish or Standard times"]

{"sheet":"Riders & Times","index":1,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
["Event"]
[]
["Race Distance",16.2,"km"]
["Standards Distance",16,"km",null,{"$f":"IF(B4=16,\"Standards!B2:B105\",IF(B4=40,\"Standards!C2:C105\",\"Standards!D2:D105\"))","v":"Standards!B2:B105"}]
[]
["Rider","Team Affiliation","Gender","Age",null,"Standard Time","Finish Time","Std"," +/-"]
[null,null,"M",null,{"$f":"IF(AND(C7<>\"\",D7<>\"\"),CONCATENATE($C7,IF($C7=\"M\",IF($D7<30,30,IF($D7>85,85,$D7)),IF($D7<30,30,IF($D7>77,77,$D7)))),\"\")","v":""},{"$f":"IF($E7<>\"\",LOOKUP($E7,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,{"$f":"IF(AND(G7<>\"\",F7<>\"\"),IF(G7>F7, G7-F7, F7-G7),\"\")","v":""},{"$f":"IF(AND(G7<>\"\",F7<>\"\"),IF(G7>F7, \"+\", \"-\"),\"\")","v":""}]
[null,null,"M",null,{"$f":"IF(AND(C8<>\"\",D8<>\"\"),CONCATENATE($C8,IF($C8=\"M\",IF($D8<30,30,IF($D8>85,85,$D8)),IF($D8<30,30,IF($D8>77,77,$D8)))),\"\")","v":""},{"$f":"IF($E8<>\"\",LOOKUP($E8,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,{"$f":"IF(AND(G8<>\"\",F8<>\"\"),IF(G8>F8, G8-F8, F8-G8),\"\")","v":""},{"$f":"IF(AND(G8<>\"\",F8<>\"\"),IF(G8>F8, \"+\", \"-\"),\"\")","v":""}]
[null,null,"M",null,"",{"$f":"IF($E9<>\"\",LOOKUP($E9,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E10<>\"\",LOOKUP($E10,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E11<>\"\",LOOKUP($E11,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E12<>\"\",LOOKUP($E12,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E13<>\"\",LOOKUP($E13,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E14<>\"\",LOOKUP($E14,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E15<>\"\",LOOKUP($E15,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E16<>\"\",LOOKUP($E16,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E17<>\"\",LOOKUP($E17,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E18<>\"\",LOOKUP($E18,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E19<>\"\",LOOKUP($E19,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E20<>\"\",LOOKUP($E20,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E21<>\"\",LOOKUP($E21,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E22<>\"\",LOOKUP($E22,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E23<>\"\",LOOKUP($E23,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E24<>\"\",LOOKUP($E24,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E25<>\"\",LOOKUP($E25,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E26<>\"\",LOOKUP($E26,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E27<>\"\",LOOKUP($E27,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E28<>\"\",LOOKUP($E28,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E29<>\"\",LOOKUP($E29,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E30<>\"\",LOOKUP($E30,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E31<>\"\",LOOKUP($E31,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E32<>\"\",LOOKUP($E32,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E33<>\"\",LOOKUP($E33,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E34<>\"\",LOOKUP($E34,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E35<>\"\",LOOKUP($E35,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E36<>\"\",LOOKUP($E36,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E37<>\"\",LOOKUP($E37,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E38<>\"\",LOOKUP($E38,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E39<>\"\",LOOKUP($E39,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,"",{"$f":"IF($E40<>\"\",LOOKUP($E40,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E41<>\"\",LOOKUP($E41,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E42<>\"\",LOOKUP($E42,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E43<>\"\",LOOKUP($E43,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E44<>\"\",LOOKUP($E44,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E45<>\"\",LOOKUP($E45,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E46<>\"\",LOOKUP($E46,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E47<>\"\",LOOKUP($E47,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E48<>\"\",LOOKUP($E48,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E49<>\"\",LOOKUP($E49,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E50<>\"\",LOOKUP($E50,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E51<>\"\",LOOKUP($E51,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E52<>\"\",LOOKUP($E52,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E53<>\"\",LOOKUP($E53,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E54<>\"\",LOOKUP($E54,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E55<>\"\",LOOKUP($E55,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]
[null,null,"M",null,null,{"$f":"IF($E56<>\"\",LOOKUP($E56,Standards!$A$2:$A$105,INDIRECT($E$4)) * ($B$3/$B$4),\"\")","v":""},null,"",""]

{"sheet":"Results","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Results based on Finish Times"]
["Rider","Team Affiliation","Gender","Age","Standard Time","Finish Time","Std"," +/-"]
[]
[]
[null,null,null,null,"",null,"",""]
[null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,""]

{"sheet":"Standards","index":3,"n_rows":105,"n_cols":4,"rows_kept":105,"cut":false,"hidden":false,"merged":[]}
["Class","16km","40km","80km"]
["F30","00:24:40","01:04:14","02:12:37"]
["F31","00:24:50","01:04:40","02:13:31"]
["F32","00:25:00","01:05:06","02:14:25"]
["F33","00:25:11","01:05:34","02:15:24"]
["F34","00:25:22","01:06:03","02:16:23"]
["F35","00:25:33","01:06:32","02:17:22"]
["F36","00:25:44","01:07:00","02:18:21"]
["F37","00:25:55","01:07:30","02:19:20"]
["F38","00:26:06","01:07:58","02:20:19"]
["F39","00:26:18","01:08:29","02:21:24"]
["F40","00:26:30","01:09:01","02:22:28"]
["F41","00:26:42","01:09:32","02:23:33"]
["F42","00:26:54","01:10:03","02:24:37"]
["F43","00:27:06","01:10:34","02:25:42"]
["F44","00:27:18","01:11:06","02:26:46"]
["F45","00:27:30","01:11:37","02:27:51"]
["F46","00:27:42","01:12:08","02:28:55"]
["F47","00:27:54","01:12:39","02:30:00"]
["F48","00:28:06","01:13:11","02:31:05"]
["F49","00:28:18","01:13:42","02:32:09"]
["F50","00:28:30","01:14:13","02:33:14"]
["F51","00:28:43","01:14:48","02:34:23"]
["F52","00:28:56","01:15:21","02:35:33"]
["F53","00:29:09","01:15:55","02:36:43"]
["F54","00:29:22","01:16:29","02:37:53"]
["F55","00:29:35","01:17:02","02:39:03"]
["F56","00:29:48","01:17:36","02:40:13"]
["F57","00:30:01","01:18:10","02:41:23"]
["F58","00:30:14","01:18:44","02:42:33"]
["F59","00:30:27","01:19:18","02:43:43"]
["F60","00:30:40","01:19:52","02:44:53"]
["F61","00:30:54","01:20:28","02:46:08"]
["F62","00:31:08","01:21:05","02:47:23"]
["F63","00:31:22","01:21:41","02:48:38"]
["F64","00:31:36","01:22:18","02:49:54"]
["F65","00:31:50","01:22:54","02:51:09"]
["F66","00:32:04","01:23:30","02:52:24"]
["F67","00:32:18","01:24:07","02:53:39"]
["F68","00:32:32","01:24:43","02:54:55"]
["F69","00:32:46","01:25:20","02:56:10"]
["F70","00:33:00","01:25:56","02:57:25"]
["F71","00:33:15","01:26:35","02:58:46"]
["F72","00:33:30","01:27:14","03:00:06"]
["F73","00:33:45","01:27:53","03:01:27"]
["F74","00:34:00","01:28:33","03:02:48"]
["F75","00:34:15","01:29:12","03:04:08"]
["F76","00:34:30","01:29:51","03:05:29"]
["F77","00:34:45","01:30:30","03:06:50"]
["M30","00:23:30","01:01:12","02:06:21"]
["M31","00:23:38","01:01:32","02:07:04"]
["M32","00:23:46","01:01:53","02:07:47"]
["M33","00:23:54","01:02:14","02:08:30"]
["M34","00:24:03","01:02:38","02:09:18"]
["M35","00:24:12","01:03:01","02:10:06"]
["M36","00:24:21","01:03:24","02:10:55"]
["M37","00:24:30","01:03:48","02:11:43"]
["M38","00:24:40","01:04:14","02:12:37"]
["M39","00:24:50","01:04:40","02:13:31"]
["M40","00:25:00","01:05:06","02:14:25"]
["M41","00:25:11","01:05:34","02:15:24"]
["M42","00:25:22","01:06:03","02:16:23"]
["M43","00:25:33","01:06:32","02:17:22"]
["M44","00:25:44","01:07:00","02:18:21"]
["M45","00:25:55","01:07:30","02:19:20"]
["M46","00:26:06","01:07:58","02:20:19"]
["M47","00:26:18","01:08:29","02:21:24"]
["M48","00:26:30","01:09:01","02:22:28"]
["M49","00:26:42","01:09:32","02:23:33"]
["M50","00:26:54","01:10:03","02:24:37"]
["M51","00:27:06","01:10:34","02:25:42"]
["M52","00:27:18","01:11:06","02:26:46"]
["M53","00:27:30","01:11:37","02:27:51"]
["M54","00:27:42","01:12:08","02:28:55"]
["M55","00:27:54","01:12:39","02:30:00"]
["M56","00:28:06","01:13:11","02:31:05"]
["M57","00:28:18","01:13:42","02:32:09"]
["M58","00:28:30","01:14:13","02:33:14"]
["M59","00:28:43","01:14:48","02:34:23"]
["M60","00:28:56","01:15:21","02:35:33"]
["M61","00:29:09","01:15:55","02:36:43"]
["M62","00:29:22","01:16:29","02:37:53"]
["M63","00:29:35","01:17:02","02:39:03"]
["M64","00:29:48","01:17:36","02:40:13"]
["M65","00:30:01","01:18:10","02:41:23"]
["M66","00:30:14","01:18:44","02:42:33"]
["M67","00:30:27","01:19:18","02:43:43"]
["M68","00:30:40","01:19:52","02:44:53"]
["M69","00:30:54","01:20:28","02:46:08"]
["M70","00:31:08","01:21:05","02:47:23"]
["M71","00:31:22","01:21:41","02:48:38"]
["M72","00:31:36","01:22:18","02:49:54"]
["M73","00:31:50","01:22:54","02:51:09"]
["M74","00:32:04","01:23:30","02:52:24"]
["M75","00:32:18","01:24:07","02:53:39"]
["M76","00:32:32","01:24:43","02:54:55"]
["M77","00:32:46","01:25:20","02:56:10"]
["M78","00:33:00","01:25:56","02:57:25"]
["M79","00:33:15","01:26:35","02:58:46"]
["M80","00:33:30","01:27:14","03:00:06"]
["M81","00:33:45","01:27:53","03:01:27"]
["M82","00:34:00","01:28:33","03:02:48"]
["M83","00:34:15","01:29:12","03:04:08"]
["M84","00:34:30","01:29:51","03:05:29"]
["M85","00:34:45","01:30:30","03:06:50"]